package com.lagou.repository;

import com.lagou.entity.COrder;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;

import java.util.List;

public interface COrderRepository extends JpaRepository<COrder,Long> {

    @Query(value = "select * from c_order where company_id =?1 ",nativeQuery = true)
    List<COrder> findbyCompanyId(int companyId);

}
